package com.etooling.framework.repository;


import com.etooling.framework.entity.SmsLog;
import org.springframework.data.jpa.repository.Query;
import org.springframework.stereotype.Repository;

@Repository
public interface SmsLogRepository extends BaseRepository<SmsLog> {

    @Query(nativeQuery = true, value = "select * from framework.t_sms_log sl where sl.mobile_no=?1 order by create_time desc limit 1 ")
    SmsLog getLastLog(String mobile);
}
